UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1TgfnuaeLH62wTPn6O4FjFEH0ZnWRuDea5ejS5P5/2c='
WHERE
key_id = '4bff89ed4218681518c8e0a9c296c0beee6679122e9616d49339d4a4e321a5df'
AND (
token = '1TgfnuaeLH62wTPn6O4FjFEH0ZnWRuDea5ejS5P5/2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)