UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8Yj2rIbtsfB/7ZIF1tWpPE5OmJ/VH3dgQ3wfgJ9xX4='
WHERE
key_id = 'a8b8e455558a3321ad177890b2136cd9d84d884a565add9047bc3261b34960cc'
AND (
token = 'J8Yj2rIbtsfB/7ZIF1tWpPE5OmJ/VH3dgQ3wfgJ9xX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)