UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XlWxa8KYa3uFOiTlJyrPP+GctRC+oBojbm5zTtAt/S4='
WHERE
key_id = '364d80bb26069bbea278ad65cc4acc3bd92be028e05a9ce4f70392164c6b37c2'
AND (
token = 'XlWxa8KYa3uFOiTlJyrPP+GctRC+oBojbm5zTtAt/S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)