UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'L4vz2c+6BbvjBltJiEsl7Svh9YLODCYTk/nTAJbY8SA=' 
WHERE 
  key_id = '4f23d1763699c4520e29b438f3ad6e3e375235219c51ade64050234b5f2c5e4a' 
  AND (
    token = 'L4vz2c+6BbvjBltJiEsl7Svh9YLODCYTk/nTAJbY8SA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032