UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6Vtiy5sEoM6yrsayVip7Bh080Ncnxczft5j/dtNc+A='
WHERE
key_id = '8a9dfbbdf66272b551e3b1f0b9dcc30efe34f42c996f1f20ed93ce0dcfd9298a'
AND (
token = 'i6Vtiy5sEoM6yrsayVip7Bh080Ncnxczft5j/dtNc+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)