UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nLayaKUcBSfICEBoPluj73cT2T8ikr6MThfrYCK9zWk='
WHERE
key_id = 'defe9c897dbb2c7a920db0fc0d81e2b47b49780a16fcd9010dc47bfaef52a627'
AND (
token = 'nLayaKUcBSfICEBoPluj73cT2T8ikr6MThfrYCK9zWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)