UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FVNRfK1QY/MqYiEKUVovQJSBqhmQzVO5pQ2K3UCLc7w='
WHERE
key_id = '338433bbf5afb75f1ab2a6589cdb257fe3783af86f481ac17b6f14deb58430cf'
AND (
token = 'FVNRfK1QY/MqYiEKUVovQJSBqhmQzVO5pQ2K3UCLc7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)