UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TP/EIb50CoN62AcEYxAGYYRoqYDhsT7Wu40I2NWH6+A='
WHERE
key_id = '3e6c416110b0b64bf4ca6b2488e52514be01a2bf242053a8b4a645d1bf53ae54'
AND (
token = 'TP/EIb50CoN62AcEYxAGYYRoqYDhsT7Wu40I2NWH6+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)