UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLo1QZ4mha5QjCtMgxuoFe986V8hI+C/TFxtqsPgGe8='
WHERE
key_id = '2293615d5cb8ac151f4cd1321bb7448099c087569164b989763bd61b941bd7dc'
AND (
token = 'pLo1QZ4mha5QjCtMgxuoFe986V8hI+C/TFxtqsPgGe8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)