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

Query time 0.00029