UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2zh6Zu8kIoPiA9dZM+yuITEaXO1drREWIkoCj/A+Etc='
WHERE
key_id = '52ac6ee75af45c668748e066196985ab8775146e5fd2437e2024e3f508773ba1'
AND (
token = '2zh6Zu8kIoPiA9dZM+yuITEaXO1drREWIkoCj/A+Etc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)