UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Qa+b6vf64/mafy/0q6D/GBc42Io+Zz/ssUR8PXs7al8=' 
WHERE 
  key_id = '97ab4ba872d978bf41c16464af6a1c479d0c9cb74ef785f2d90f5b37231e75a1' 
  AND (
    token = 'Qa+b6vf64/mafy/0q6D/GBc42Io+Zz/ssUR8PXs7al8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027