UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MiwGE9DgKgY+dNO3vFe8Cp+55OMsfCRnkw3dz9/oZEw='
WHERE
key_id = '2c7d661b2e4b9be71fb428954c20539f727416f140a759c0046a10ac2ac67fb0'
AND (
token = 'MiwGE9DgKgY+dNO3vFe8Cp+55OMsfCRnkw3dz9/oZEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)