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

Query time 0.00024