UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nSU60ERXb6Q+CZXVqO3bN2tu60lxPNZM5QvxjhDWzbc=' 
WHERE 
  key_id = '23ca73b53fd97fa9086703aee4fb29717ab4c4599e86e95455549666afab1b0f' 
  AND (
    token = 'nSU60ERXb6Q+CZXVqO3bN2tu60lxPNZM5QvxjhDWzbc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053