UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGtOpN+4CgalBc6mwEi7gbvdFdGZJA8ZSUBlhTLg3EQ='
WHERE
key_id = 'f46ce95c81d8166e8c76617e9db7e9a037f201cb9d6b3c327cb351e4ff1f5d80'
AND (
token = 'XGtOpN+4CgalBc6mwEi7gbvdFdGZJA8ZSUBlhTLg3EQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)