UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CcP45QKs31VgnEaL1taJs059lYvRd/S/m6kyWW4EiqE=' 
WHERE 
  key_id = 'e052fae796a6e94e39584ff390888d8a8f009785b04f7427d0a581c37174a08e' 
  AND (
    token = 'CcP45QKs31VgnEaL1taJs059lYvRd/S/m6kyWW4EiqE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029