UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HhKUq8wK+WD53WqHtX0W49Kl6PCBG6c6TVyzKewJb7Y=' 
WHERE 
  key_id = '9074e59ba1b1728b6dd0e043a79baeabbe9500b6269475614747c79b25184d4b' 
  AND (
    token = 'HhKUq8wK+WD53WqHtX0W49Kl6PCBG6c6TVyzKewJb7Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020