UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XBoaJ/wtnSrl+wC1R4ngndCCLFQ6FwrJ1raRxVpKNQ='
WHERE
key_id = 'cde7803f6681be4b3100d82a2bd1d222081d0e34f4f75bae57902714a3b50fd9'
AND (
token = '6XBoaJ/wtnSrl+wC1R4ngndCCLFQ6FwrJ1raRxVpKNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)