UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6mWK9sYFx/h9Y0paUOpzM8CSdToTg4qBtXN0jqxpKw4='
WHERE
key_id = 'f88a891321511d6d81ec469c2a84395b0612d70726b7945b020abad92a2fd148'
AND (
token = '6mWK9sYFx/h9Y0paUOpzM8CSdToTg4qBtXN0jqxpKw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)