UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6B8B/yYki74PBBMxb/b+4fNdw8bxvH+qXeq6SaEPI4U='
WHERE
key_id = 'f95fc01e006fdc88d1e1a265bc63dd17f9f56f045338bc67098cf21b283c733a'
AND (
token = '6B8B/yYki74PBBMxb/b+4fNdw8bxvH+qXeq6SaEPI4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)