UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kApLLr7082DfqrawNBhX0czxdgi44RzJrM1yVuhw4nU='
WHERE
key_id = 'ff69fba4fa4365f8fa602b7878819dabd7b2cc7edc0c87013bb39e829f519ed8'
AND (
token = 'kApLLr7082DfqrawNBhX0czxdgi44RzJrM1yVuhw4nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)