UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fDVxBQ3XeiiX872hVfMHHK7C+qvB8JqE/veA3nx/VRU='
WHERE
key_id = '9a9c089a8bc56a52dd387df58008304ea2d8e3490f79b0953d61c91988749f12'
AND (
token = 'fDVxBQ3XeiiX872hVfMHHK7C+qvB8JqE/veA3nx/VRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)