UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Jg5NUbtEz9u0dECKXAif1qhfQI8SdyMlCvfaT31mZw='
WHERE
key_id = 'bca242d457428ffb793e24408fc4047c5563f571a8bd830e197c40d11456f8f4'
AND (
token = '5Jg5NUbtEz9u0dECKXAif1qhfQI8SdyMlCvfaT31mZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)