UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jsm1JQxTUf4Mfs7U0CmI07rYPWqgxNKTwMypbUqNQC0='
WHERE
key_id = '7c47046517b859d9ccf2ba5088886a360c97913941862d6f43f5fb95b2022195'
AND (
token = 'Jsm1JQxTUf4Mfs7U0CmI07rYPWqgxNKTwMypbUqNQC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)