UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xk+NIocG0TrpbgKGMM3qly5bZP2CeDU327Rl+Q+oXKg='
WHERE
key_id = 'dd85b173d15e730ca70ce4fd715a6235026471260c83fbc3c90a58ba231097cb'
AND (
token = 'xk+NIocG0TrpbgKGMM3qly5bZP2CeDU327Rl+Q+oXKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)