UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdVgHuRemuZ2g7ZaVbxpjX+pAFtRRxwE8VmCc49HeU0='
WHERE
key_id = 'cfbb66d04d78ee883e6dd189955c9965d2adeb88d4584dc4b73016bad50e61a4'
AND (
token = 'ZdVgHuRemuZ2g7ZaVbxpjX+pAFtRRxwE8VmCc49HeU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)