UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jBIzxIZKjp9ZTTezjq2THmkxAv4HiS66MI/d2uALeZw='
WHERE
key_id = '8e2b8cc5272e4adb7dede34ec56589d70e990308a0ee25f02bc874415b07d9fc'
AND (
token = 'jBIzxIZKjp9ZTTezjq2THmkxAv4HiS66MI/d2uALeZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)