UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VLqk0DWarkM0gKn0vp2YqBLcw6YbzKWtw/kpg0o5ZIo=' 
WHERE 
  key_id = '64cd633386ce3bc4a55bd48892f60c23f7636561ff5c56ec6d6bb02d06a84532' 
  AND (
    token = 'VLqk0DWarkM0gKn0vp2YqBLcw6YbzKWtw/kpg0o5ZIo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025