UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnpEZD7odO4GvCmqmNmIO0TVviPKiVHUFnzZ9O8SHb0='
WHERE
key_id = 'e2f23ad113090cb19518e8db6301b67b56135ce1e2ffe06006841518d0620936'
AND (
token = 'QnpEZD7odO4GvCmqmNmIO0TVviPKiVHUFnzZ9O8SHb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)