UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5LRwze0/8Y8h7VDSIOos4iIUSDXaX/v/Ih4VDFN1fQo=' 
WHERE 
  key_id = '53ef5b3c5c33353a1c931e9bace8b72591a5643102acb5e6e1fb3d604993029a' 
  AND (
    token = '5LRwze0/8Y8h7VDSIOos4iIUSDXaX/v/Ih4VDFN1fQo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035