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