UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47AFMmM2vuqbrwlcG7PK7Pj80pvWnNw/ZAsHrx1Y3Vo='
WHERE
key_id = 'f7e2149d815b669af802e47ff8c3a4ee30498eb8f8faa4275b33122cc8f99ec4'
AND (
token = '47AFMmM2vuqbrwlcG7PK7Pj80pvWnNw/ZAsHrx1Y3Vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)