UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sk4XD9KT3iMkbyfhj5JQ3mStX+xgVKpwmukxPqePBHI='
WHERE
key_id = '8d0c5fa72abdaa59c4812e6b0171ba16cb15d8df6ffe8c149d9d98684cf3273f'
AND (
token = 'Sk4XD9KT3iMkbyfhj5JQ3mStX+xgVKpwmukxPqePBHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)