UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't4WT+ewRa/YUy6PBVLI3V4moAZImKDFWgUpr4Z5U6h8=' 
WHERE 
  key_id = 'aafc0d354afa6ba3b34d065da6b6a095467a20eb2d03de02d2202e777cacce59' 
  AND (
    token = 't4WT+ewRa/YUy6PBVLI3V4moAZImKDFWgUpr4Z5U6h8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036