UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tTFy7Ckn7J2RwrckkGi0Eth3Ovkzvi7mJqJv/q0XsA='
WHERE
key_id = '49b71216513c7885c1ad010bc8cd30eaafdc568784d6fc20cb70e77e8456f002'
AND (
token = '0tTFy7Ckn7J2RwrckkGi0Eth3Ovkzvi7mJqJv/q0XsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)