UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UzC0JY87P8IMAyWyYBf1pqmuT2+nn4txE+kdsms5D1k='
WHERE
key_id = '9507a2fb7c35ab54e88d4403221764cfd3514a12f96797a2dd38f24204e82bb0'
AND (
token = 'UzC0JY87P8IMAyWyYBf1pqmuT2+nn4txE+kdsms5D1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)