UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vt2oZRTzzWFvIxVH20K87IE6ow/a/9JU0IlZn6Cka7c=' 
WHERE 
  key_id = '7b01798c1c23c2358576163e81dda308ae5f3cf4cd09a285862ed112142a8ffa' 
  AND (
    token = 'vt2oZRTzzWFvIxVH20K87IE6ow/a/9JU0IlZn6Cka7c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027