UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DreAkK2qCsyj89AE3fmWmRZRFqH3AY0K2msE4HV20CA=' 
WHERE 
  key_id = 'a55f0a1a01a4bf9f8561c1f9433c149cb09a800fe211d3dc8d88ef07c186cb12' 
  AND (
    token = 'DreAkK2qCsyj89AE3fmWmRZRFqH3AY0K2msE4HV20CA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022