UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JTy4T0guVc0XGLO7Al91Qfm4lpAkxRi8xNSrkFbaTWo=' 
WHERE 
  key_id = '28d07883452b2a0ad5d8b482c50b2259545aa4822d0a8e77c7295f9031e89aed' 
  AND (
    token = 'JTy4T0guVc0XGLO7Al91Qfm4lpAkxRi8xNSrkFbaTWo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028