UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pbV+HAi+9C2PnbZLUa8vggMCfAE9xpVpvdX3shhG55Y='
WHERE
key_id = 'ea170d23809ef4b610eb85e20a96b9b1519d13e8bccc4ee21937954e87e77040'
AND (
token = 'pbV+HAi+9C2PnbZLUa8vggMCfAE9xpVpvdX3shhG55Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)