UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2yX/yLNUjSXbviD4vLb7cpq6dcXPLhva7PT7lsS8mSg=' 
WHERE 
  key_id = '53e98e14bff60fbd840a9d969fdcfee9046225cd97c9f22d849106d5936e1bb6' 
  AND (
    token = '2yX/yLNUjSXbviD4vLb7cpq6dcXPLhva7PT7lsS8mSg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046