UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '447fKh4zbd55eZYDpMylnqwEvDhkzeKFM35aB//ajC0='
WHERE
key_id = 'a6d7c80f39fd2c345d61e9b3c9fd2d41e0233f0cf4b0ef74364acd9724918301'
AND (
token = '447fKh4zbd55eZYDpMylnqwEvDhkzeKFM35aB//ajC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)