UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cGgxiGc75PQKOXcG0CxNr3UnGPln9utkzTDWp7UqYmM='
WHERE
key_id = '696fa043599815d4bf94d903cb89e7d9ec7a4cc17a8b979b4d2cb885b3f5efdd'
AND (
token = 'cGgxiGc75PQKOXcG0CxNr3UnGPln9utkzTDWp7UqYmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)