UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htUIChutVAquVpnwcIfBhxtzEtLnD24f2cMLdOwPzuw='
WHERE
key_id = '9afc0741649859d92e7349e80985b24c045c28d8fdb9d9cea237806a268a2139'
AND (
token = 'htUIChutVAquVpnwcIfBhxtzEtLnD24f2cMLdOwPzuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)