UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3oxKoc2kZyk6wI9G4SP1KEzfhaKe5RhM4TOtDyja2zk=' 
WHERE 
  key_id = '2ccb9b6e2ebad1bcd69ab373c3141a548a05b6c97f830478048e52f14fa59d46' 
  AND (
    token = '3oxKoc2kZyk6wI9G4SP1KEzfhaKe5RhM4TOtDyja2zk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023