UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xmUM3e/mdXVufFoLTYUb3/onJiuZYNTCeB/DSOvTQgI='
WHERE
key_id = 'a4404e24a640fb7d67e2b638dcb8a4f6303c096d5ddf5b7e14e2da1fc300d682'
AND (
token = 'xmUM3e/mdXVufFoLTYUb3/onJiuZYNTCeB/DSOvTQgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)