UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9KxZSxL7mAv2hP40MQjFJ8wbaCePRwboI5Boi2Syj9g='
WHERE
key_id = '07a5cd4fdf7d985e69e49c54bf7e40a3914fbd06acdbbcd9195a8cd12cf677e9'
AND (
token = '9KxZSxL7mAv2hP40MQjFJ8wbaCePRwboI5Boi2Syj9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)