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