UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1U2WZ5Ren6oZcDx5CcX5V7jAsVaxo3maPw8HdaE5njU='
WHERE
key_id = '8616ebf5351736255b8a977f46f4f8162659073776d51d5c9c0a63198f13d382'
AND (
token = '1U2WZ5Ren6oZcDx5CcX5V7jAsVaxo3maPw8HdaE5njU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)