UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CT85PeZlW2FHUYj7mVHkiJxjMeln6li0dE4P3zJhMR4='
WHERE
key_id = '9f4d6cc4c85cbabcae35be89a0378ea886946e9917295371818ad9506e81c7f2'
AND (
token = 'CT85PeZlW2FHUYj7mVHkiJxjMeln6li0dE4P3zJhMR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)