UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8XOpyNey0lxKTSrNBpo+L8mVvqVMB3Ai2Kbe1kFHwOU='
WHERE
key_id = 'f71b4ede61f2e5712eeeb4aa4813328e2aacfd1e38dc150b3f9be1e2bd2c3d8a'
AND (
token = '8XOpyNey0lxKTSrNBpo+L8mVvqVMB3Ai2Kbe1kFHwOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)