UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nrTwRwfWiHrMiuCs0sLiVrgHAzhDvgAvLTzX5NM8gYU=' 
WHERE 
  key_id = '36f9effd0eaf84c5d9fe8de243f7dd1a4d0759acaf0196e6681ea3e184413058' 
  AND (
    token = 'nrTwRwfWiHrMiuCs0sLiVrgHAzhDvgAvLTzX5NM8gYU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026