UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EXA9bRgzCaxWI1PRbl5CTj0/mZIwPkQpzNCeBf0Dg0I=' 
WHERE 
  key_id = '690f3e44de1f358c017df2d7145f40adae0625629cda3070ce489d5e581f1663' 
  AND (
    token = 'EXA9bRgzCaxWI1PRbl5CTj0/mZIwPkQpzNCeBf0Dg0I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021