UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KO/K2T4R5su3w/URZH8BMQuh4P2Z1sXkKxu9837IjxU='
WHERE
key_id = 'c644e09c7b1b957f16ab0097c0a334bf48ba29deb187a85118538827166965d5'
AND (
token = 'KO/K2T4R5su3w/URZH8BMQuh4P2Z1sXkKxu9837IjxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)