UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9KlAspFNN5A9HTzhv03+KJh0LIWf6impfycTC+nOC0='
WHERE
key_id = '1ace56dde316efb4f324ddf3078fdb17b907116a0f9380c54a5cfc211b456111'
AND (
token = 'C9KlAspFNN5A9HTzhv03+KJh0LIWf6impfycTC+nOC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)