UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ce6g8fEec+rRXLL0yJ//F0ki9RjjkltwUtqPBI+tHTw=' 
WHERE 
  key_id = '60a6452860fdc7b70171e586d426876f69249353a400e27d458cb074679286cf' 
  AND (
    token = 'ce6g8fEec+rRXLL0yJ//F0ki9RjjkltwUtqPBI+tHTw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042