UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'b78tyr0cnm8tXQzHQ4SPcbQc+JMtcH4+Zo/3qys4hGw=' 
WHERE 
  key_id = '51d695e6a636c6a1513ac6dd3e58e17d18480203c71ee152927f005f6816369b' 
  AND (
    token = 'b78tyr0cnm8tXQzHQ4SPcbQc+JMtcH4+Zo/3qys4hGw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027