UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bgMxc9cyQp2y0shk5nEq5kifU9wdm7dRK7doeQgnfdo='
WHERE
key_id = '101188f6485ca9459fd211bd047bd3ae93431efa379fe598559d912aca4846cc'
AND (
token = 'bgMxc9cyQp2y0shk5nEq5kifU9wdm7dRK7doeQgnfdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)