UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6USwaG5NIld4NVxM5Kbc6VbW0CCZ3reMXLlxQravfVA='
WHERE
key_id = '31d6ce43bea85397120a0e28befe7e5a48e46ad8ce8bc8e763bf5452e8426e47'
AND (
token = '6USwaG5NIld4NVxM5Kbc6VbW0CCZ3reMXLlxQravfVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)