UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VupkEj69Yt9eR18Jy4ebMGo4OA0cAcsqigxFcF0IQeo=' 
WHERE 
  key_id = '8ab154868c7a9547748a1a452ed6f5349d5496b873bad2c2c7f5e0ede8baa48e' 
  AND (
    token = 'VupkEj69Yt9eR18Jy4ebMGo4OA0cAcsqigxFcF0IQeo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053